rfletcher35
Active Member
- Joined
- Jul 20, 2011
- Messages
- 300
- Office Version
- 365
- Platform
- Windows
I'm adding a search to my workbook based on a drop down list of 4 criteria. I've managed to pretty much do this using the offset command in my formulas. But if my VLOOKUP searches on columns 2,3,or 4 how can I do it so it also returns the value in column 1 in the cell I need?
=IFERROR(VLOOKUP(B5,OFFSET(STOCK,0,1),1,0),"") is what I have that returns what I have searched for in column2 of my range
What do I need to return the value of column 1 that corresponds with the data in column 2?
Any ideas please
Fletch
=IFERROR(VLOOKUP(B5,OFFSET(STOCK,0,1),1,0),"") is what I have that returns what I have searched for in column2 of my range
What do I need to return the value of column 1 that corresponds with the data in column 2?
Any ideas please
Fletch