VLOOKUP evaluating 2 columns

[ddub25]

I've been trying to get a VLOOKUP to look at text in Column B and in Column I (in the same row) on one sheet and then find the exact same text values held in Column BV and Column BW (in another workbook called 'REF' and on a sheet within the workbook called 'ref1'). When it finds these values, I want it to return the text held in Column BX.

I've been struggling to get the correct syntax to incorporate the 2 initial column references. Can anyone help.

Dan

 

[Marcelo Branco]

Matty,

Yes, very good to spare computational resources and to keep the formulas simpler.

Tks for the reply.

M.

 

[Matty]

Yes, very good to spare computational resources and to keep the formulas simpler.

Indeed.

Tks for the reply.

Happy to help.

Matty

 

[Matty]

Hi Marcelo,

I should have qualified something before. If the value being returned is numeric, then the formula should be:

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,formula))

Notice how the quotes around the 0 have gone, as the formula would return #N/A if they were there and the lookup value had not been found.

Matty

 

[Marcelo Branco]

Hi Marcelo,

I should have qualified something before. If the value being returned is numeric, then the formula should be:

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,formula))

Notice how the quotes around the 0 have gone, as the formula would return #N/A if they were there and the lookup value had not been found.

Matty

Yes, yes!

When replying i have just copied and pasted your formula without care, but i had already made tests with 0 (no double-quotes) and it worked perfect.

Tks, again, for your attention.

M.

 

[Matty]

Yes, yes!

When replying i have just copied and pasted your formula without care, but i had already made tests with 0 (no double-quotes) and it worked perfect.

Tks, again, for your attention.

M.

Good work!