Please help with Excel Formula

[Damil4real]

Okay, I have three sheets in a workbook.

In Sheet1, I have list of names starting from G3 downwards.
In Sheet 2, I have list of data in column A to C (with names in column
A2 downwards)
In Sheet 3, I have a list of data in column A to C (with different
names in column A2 downwards)

I want to have an excel lookup/match formula in Sheet1 that will pick
up the name in G3 and look for it in column A Sheet2 and return the
data in column B Sheet 2

If however, the name in G3 couldn’t be found in Sheet 2, I want the
formula to then look for the name in column A in Sheet 3, and return
the data in column B Sheet3.

The formula I have to return from Sheet2 (different sheet name &
different column) is:

=IF(COUNTIF(AllCompanies,$A3)<>0,VLOOKUP('Data Sheet'!$A3,AllData,
3,FALSE),"")

The formula I have to return from Sheet3 (different sheet name &
column) is:

=IF(COUNTIF(AllCompanies1,$A13)<>0,VLOOKUP('Data Sheet'!
$A13,AllData1,2,FALSE),"")

I don’t know how to merge the two formulas or if it’s even possible.

I don’t want to have to merge both sheets.

Please assist.

Thanks!

 

[Bob Phillips]

I am not seeing where the different sheets are, the lookup is into the same
table in both formulae.

It would just be something like

=IF(NOT(ISNA(lookup_formula_1)),lookup_formula_1,IF(ISNA(lookup_formula_2),"",lookup_formula_2))



--
__________________________________
HTH

Bob

Okay, I have three sheets in a workbook.

In Sheet1, I have list of names starting from G3 downwards.
In Sheet 2, I have list of data in column A to C (with names in column
A2 downwards)
In Sheet 3, I have a list of data in column A to C (with different
names in column A2 downwards)

I want to have an excel lookup/match formula in Sheet1 that will pick
up the name in G3 and look for it in column A Sheet2 and return the
data in column B Sheet 2

If however, the name in G3 couldn’t be found in Sheet 2, I want the
formula to then look for the name in column A in Sheet 3, and return
the data in column B Sheet3.

The formula I have to return from Sheet2 (different sheet name &
different column) is:

=IF(COUNTIF(AllCompanies,$A3)<>0,VLOOKUP('Data Sheet'!$A3,AllData,
3,FALSE),"")

The formula I have to return from Sheet3 (different sheet name &
column) is:

=IF(COUNTIF(AllCompanies1,$A13)<>0,VLOOKUP('Data Sheet'!
$A13,AllData1,2,FALSE),"")

I don’t know how to merge the two formulas or if it’s even possible.

I don’t want to have to merge both sheets.

Please assist.

Thanks!

 

[Damil4real]

I am not seeing where the different sheets are, the lookup is into the same
table in both formulae.

It would just be something like

=IF(NOT(ISNA(lookup_formula_1)),lookup_formula_1,IF(ISNA(lookup_formula_2),­"",lookup_formula_2))

--
__________________________________
HTH

Bob


Okay, I have three sheets in a workbook.

In Sheet1, I have list of names starting from G3 downwards.
In Sheet 2, I have list of data in column A to C (with names in column
A2 downwards)
In Sheet 3, I have a list of data in column A to C (with different
names in column A2 downwards)

I want to have an excel lookup/match formula in Sheet1 that will pick
up the name in G3 and look for it in column A Sheet2 and return the
data in column B Sheet 2

If however, the name in G3 couldn’t be found in Sheet 2, I want the
formula to then look for the name in column A in Sheet 3, and return
the data in column B Sheet3.

The formula I have to return from Sheet2 (different sheet name &
different column) is:

=IF(COUNTIF(AllCompanies,$A3)<>0,VLOOKUP('Data Sheet'!$A3,AllData,
3,FALSE),"")

The formula I have to return from Sheet3 (different sheet name &
column) is:

=IF(COUNTIF(AllCompanies1,$A13)<>0,VLOOKUP('Data Sheet'!
$A13,AllData1,2,FALSE),"")

I don’t know how to merge the two formulas or if it’s even possible.

I don’t want to have to merge both sheets.

Please assist.

Thanks!

Thanks for your assistance!

I put in this formula as suggested, but it didn't work.

Range name is AllData in Data Sheet & AllData1 in Name Sheet.

Formula:

=IF(NOT(ISNA(VLOOKUP('Data Sheet'!$A3,AllData,3,FALSE), VLOOKUP('Data
Sheet'!$A3,AllData,3,FALSE)),IF(ISNA(VLOOKUP('Name Sheet'!
$A13,AllData1,2,FALSE),""), VLOOKUP('Name Sheet'!
$A13,AllData1,2,FALSE),"")

Thanks!