Discuss the north shore worksheet to display the result


Create a nested function in cell H2 that looks up the location code from the Beaches worksheet, looking for an exact match,and combines the code with the Identifier number in the North Shore worksheet to display the result as, GBB-6632.
On the Beach sheet Column B has the codes from B2:B14 ex. GBB on the Northshore sheet Column A has the (identifier#) numerical half of the code. This is not a (Match) function. It is per the instructor a Nested V-lookup function with concatenate function.

Request for Solution File

Ask an Expert for Answer!!
Accounting Basics: Discuss the north shore worksheet to display the result
Reference No:- TGS0700063

Expected delivery within 24 Hours