VLOOKUP query

[gmazza76]

I have a query where i think a VLOOKUP would be best to search a table
The only issue i have is that i may need to search possibly one of two columns for the search.

Ie MGR & LOC are empty below but filled on master data table.

Is there any way i can use a vlookup to check against user id and if there isnt anything that matches MAZZAG it can search for Gavin Mazza.
In the master table these are in column A for user id and column B for Name


<TABLE style="WIDTH: 221pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=295 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" width=103><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17 width=64>USER ID</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=103 x:str="NAME ">NAME </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=64 x:str="MGR ">MGR </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=64>LOC</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>MAZZAG</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0">Gavin Mazza</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR></TBODY></TABLE>
Gavin Mazza

Many Thanks

 

[Aladin Akyurek]

Since I failed to get the info in the format I wanted, I have to guess...

I'll assume a 2-column table the fomula must look at...

If the result you want to get is a text value:

=LOOKUP(REPT("z",255),CHOOSE({1,2,3},"Not Found",
     VLOOKUP(B2,Table,2,0),VLOOKUP(A2,Table,2,0)))

If the result you want to get is a numeric value:

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2,3},"Not Found",
     VLOOKUP(B2,Table,2,0),VLOOKUP(A2,Table,2,0)))

Does this get you what you have in mind?

Replace "Not Found" with 0 in the 2nd formula...