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:

- Matching date values w/ dropdown values
- Looping thru values to match w/ other 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?
- Array Formula
- Loop in formula
- Copy down formula with vba
- 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
- Quotations in Formulas and strings
- 2003 - Moving to a formula address
- formula
- Any idea how to write formula?
- Formula with conditional text
- sum formula
- Manually creating a row outline with no formula anywhere
- Blank Formula bar
- Disabling Formulas, Not calculation
- Can Any one help me writing logic for the given formula
- VBA or array formula?
- R1C1 Formula
- Paste Formula help