another vlookup q

[mpquin]

I am trying to create a formula in a single cell using VLOOKUP based on 2 separate sets of criterea. Basicall what I would like to accomplish is that if a cell returns "#N/A", then use the next piece of data to fulfill the vlookup.

In the example attached, the info in the "data to pull from" area contains partial info. The formula should be entered into C3. Hope this makes since on this fine Friday.

[NBVC]

I guess you can't use the names to find the matches?

If not, then maybe this is what you mean?

In C3, copied down:

Please Login or Register  to view this content.

[corinereyes]

Or you can try:

Please Login or Register  to view this content.

[corinereyes]

Or you can try:

Please Login or Register  to view this content.

[NBVC]

Or you can try:

Please Login or Register  to view this content.

Then why not just lookup B3 in the table in the first place.... it seems to me the OP doesn't want to depend on column B entries (perhaps because of possibility of duplicates?).

[corinereyes]

Hi NBVC,

(perhaps because of possibility of duplicates?).

Yeah, but i test, its not working if there's a duplicate name.

Should try a different approach.

Thanks !

[corinereyes]

If ever there's a duplicate name, you can try this formula, if there's a no match, it will return blank.

On c3:

Please Login or Register  to view this content.

Formula should be in array CTRL+SHIFT+ENTER, formula will be enclosed with brackets {}.

some formula based from master Rylo's example