Nested VLookups?

[NJS1982]

Hi, does anybody know if it is possible to use two VLookup formuals in one cell, then present the result of that formula to display one answer?

Currently I have two columns, to identify from another set of data, postcodes.

Column T formula is: =VLOOKUP(A5,'Org Postcodes'!$A$1:$J$105190,MATCH("ORGANISATION_POSTCODE",'Org Postcodes'!$A$1:$J$1,0),0)
Column U formula is: =VLOOKUP(A5,'Org Postcodes'!$A$1:$J$105190,MATCH("PROJECT_CONTACT_POSTCODE",'Org Postcodes'!$A$1:$J$1,0),0)

I then have a third formula that will check to see if there is anything in column T, and use it. If T is '(blank)', then it should present the return in column U:

Column V formula is: =IF(LEN(T5)+LEN(U5)=2,AA5,IF(LEN(T5)<>1,T5,U5))

I just wondered if there was any way of combining these into one cell, so I have one column and not three?

Thanks!

 

[steve the fish]

Sure you can do that. Its an important skill to learn so i want just tell you the formula ill guide you through. In your column V formula you see T5 and U5. Replace the T5 with the formula in T5 (except the = sign). So go to cell T5. In the formula bar highlight:

VLOOKUP(A5,'Org Postcodes'!$A$1:$J$105190,MATCH("ORGANISATION_POSTCODE",'Org Postcodes'!$A$1:$J$1,0),0)

Press control C. Press escape key. Go to column V5 and hightlight T5 in the formula bar. Press control V. Repeat for each instance of T5. Do the same for U5.

 

[NJS1982]

That is great, many thanks!