VLookup help needed

Mark Wood
Mark Wood used Ask the Experts™
on
I have a spreadsheet where i am trying to do a vlookup. i have done this several times before so i am not sure why it isnt working.

So on the document tab of my spreadsheet i have the following =IFERROR(VLOOKUP(C5,Table1,1,FALSE),""). C5 is the name of a compute, Table1 is on my setup tab which has computer name,ip, etc in it.

please help.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mark WoodNetwork Administrator

Author

Commented:
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
The issue is, in VLookup function, the lookup value should be in the first column of the table_array which is not the case with your formula.
You should try it like this...

In B5
=IFERROR(INDEX(Table1[VLAN],MATCH(C5,Table1[Computer Name],0)),"")

Open in new window

and copy it down.
Mark WoodNetwork Administrator

Author

Commented:
Thank you sir .. it worked perfectly
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome Mark! Glad it worked as desired.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial