Array to do Hlookup

helpexcel

Well-known Member
Joined
Oct 21, 2009
Messages
531
How would I code an array to do a kind of hlookup? I have data on sheet1 in columns A:I. I have data on sheet2 in column A. I want to look at the value on sheet2 row A and see if it is listed in the data on sheet1 columns A:I. If it is, i want the value from row 3 of the column it's in on sheet1 to appear in column B of Sheet2.

Is this doable?
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,347
Office Version
365
Platform
Windows
Something like this?

Excel Workbook
AB
1test3
2test10NoMatch
3test22
4test88
Sheet2
Excel Workbook
ABCDEFGHI
1test1test2test3test4test5test6test7test8test9
2
3123456789
Sheet1
 

helpexcel

Well-known Member
Joined
Oct 21, 2009
Messages
531
Thanks! the sheet2 columns would be flipped. So you would be looking for the numbers and returning the test#.
 

Forum statistics

Threads
1,082,587
Messages
5,366,486
Members
400,894
Latest member
frog9000

Some videos you may like

This Week's Hot Topics

Top