Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

In Excel I have a SQL query.

I want to compare the cell value in d3 "linda" on sheet1, which has

the source connection, to an array located on a different sheet.

Once found I want to return the value from column I of that row on

the second sheet .

The array is located in column A the data I want is in column I.

When I try to build my formula another column header is created on

the 1st,( that has the sql connection)

Second problem the reference the second sheet generates errors

Third I have no idea how to return the actual value that I need.

This is as far as I can get

=INDIRECT(ADDRESS(MATCH(D3,'Feed '!A2:A6934),1)

Didn't find what you were looking for?
Find more on Formula to match,lookup and then retun alternate value
Or get search suggestion and latest updates.

Related Topics:

- Looping thru values to match w/ other values
- Matching date values w/ dropdown values
- VBA code to add values in two cells which have formulas
- Copy Value produced by formula in cell C3 to cell D3
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- VBA Formula prob
- Getting a formula to copy from inside VBA
- Populate Formula(Function) in rows
- searching within formulas
- Formula using range name in VBA code
- Three Leveled Formula
- R1C1 Formula
- Paste Formula help
- VBA or array formula?
- combining formula
- How to add several conditions for formula "SUMIF"
- formula help but not vba please
- Loop in formula
- Copy down formula with vba
- Array Formula
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- Stuck on copying formula from 1 sheet to another
- Named formula/Windows dialog boxes
- cells containing formula that refer to user-defined VBA function
- sum formula