LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MoronME
 
Posts: n/a
Default how do i lookup the value of the next cell excluding the first lookedupresult

hi there,

am trying to find a solution on how to automatically generate lists
based from calculated values.

example:
i would like to have the value for D1 and D2 automatically by changing
the value of C1

C1=SupplierA --- my lookup value

A B D
1 Item Supplier jacket
2 jacket supplierA shirt
3 jeans supplierB
4 shirt supplierA
5 briefs supplierC

thank you very much in advance for the help. needed badly.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I lookup a cell that's to the left? Weasel Excel Discussion (Misc queries) 3 March 26th 06 08:06 PM
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY Scott Lolmaugh Excel Worksheet Functions 3 March 9th 06 11:05 PM
Return cell reference of lookup value bobm Excel Worksheet Functions 3 July 7th 05 08:49 AM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
double lookup, nest, or macro? Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"