Help with hlookup and if statements for dynamically-changing data

[Gary]

Will IF statements and HLOOKUP work for this and if so how? If not,
any suggestions...

I am trying to use hlookup to get data from other worksheets.

Master Spreadsheet A:

Ticker Price Daily Volume
TEST HLOOKUP->17.85 HLOOKUP->800,000

HLOOKUP works fine (=HLOOKUP("Price",[B.xls]csXLS!$A$5:$L$200,3,FALSE)
if I know the cell position of the data in advance. But on a given
day, B and C may not contain the ticker in A or may not contain it in
the same cell row/column. If they do contain the data I need in any
cell position in a given row, I want that data. If they don't, I want
"N/A" in the field in Spreadsheet A. How can I do this? Is this
possible? Please email me, too.

Spreadsheet B:

Ticker Price
TEST 17.85

Spreadsheet C:

Ticker Daily Volume
AMTD 800,000

 

[Frank Kabel]

Hi
I think VLOOKUP is what you're looking for using the Ticker symbol as
lookup value an returning the info from the price column