Lookup Issue
You will still have the branch information in columns A and B, so you
can still do that.
Pete
On May 8, 1:52*am, Jayz wrote:
Thanks for your prompt responce.
Unfortunately, the suggestion doesn't help me as the spread sheet is also
feeding other information utilitising the "Branch" names.
I wish I'd never started this project!! Ha Ha
Regards
Jayz
"Pete_UK" wrote:
I find it easier with something like this to insert a new column C in
the Info sheet and to concatenate column A and B together to give a
unique reference, i.e.:
=A1&B1
copied down.
Now you can use columns C and D as your lookup table. A typical
formula for the layout you show would be something like this in B2 of
the Working sheet:
=VLOOKUP($A2&B$1,Info!$C:$D,2,0)
Copy into C2, then down if required.
Hope this helps.
Pete
On May 8, 1:16 am, Jayz wrote:
I have a problem that I require help on.
I am working on a big spreadsheet. I have to pull information from one sheet
into another. However I have 2 lookups to do. Is this possible.
example - Info Sheet
A B C
1 Manchester ABC Total -230.30
2 Manchester DEF Total +123.34
Example - Working Sheet
A B C
1 Store Name ABC Total DEF Total
2 Manchester
I need to lookup "Manchester" and "ABC Total" to give me "-230.30" in a cell.
Any Ideas if this is possible, or another solution!!
Thanks in advance
Jayz- Hide quoted text -
- Show quoted text -
|