Hello Everyone
I'm having a hard time with this one
Basically I want lookup ATM no. in sheet 2 and return related BRANCH, ZONE ID, and CITY details, horizontally in sheet 1.
Any help would be appreciated...
Thanks
Hello Everyone
I'm having a hard time with this one
Basically I want lookup ATM no. in sheet 2 and return related BRANCH, ZONE ID, and CITY details, horizontally in sheet 1.
Any help would be appreciated...
Thanks
In the C2 range, input =VLOOKUP(B2,Sheet2!$A$2:$D$5,2,0). This will automatically input your BRANCH. For your ZONE ID and CITY, input the same formula, but change the 2 after the table range in the vlookup to a 3 and 4, respectively.
multiple-columns-horizontally-lookup.xlsx
Try this..
Try this formula in C2. Pull formula to the right and then down
=VLOOKUP($B2,Sheet2!$A$2:$D$5,COLUMNS($A1:B1),0)
Last edited by AlKey; 11-20-2014 at 10:59 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
hI c2= and drag it down and across..
Formula:
=VLOOKUP($B2,Sheet2!$A$1:Sheet2!$D$5,MATCH(Sheet1!C$1,Sheet2!$A$1:$D$1,0))
☚ Click ★ just below left if it helps, Boo?ath?![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks