Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup functions
I have a file with two spreadsheets containing data. One
contains a list of user defined entries, the other I want to summarise specific fields based upon the original entries in S/sheet 1. I am trying to use the lookup function to enter in S/sheet 2 the value driven by a field in s/sheet 1. Eg, S/sheet 1 has a client reference, names and other details. On S/sheet 2 I only want the client reference, name and one other field taken from fields in S/sheet 1. ie. Lookupif(A1="1")then return value in B2 Something messy like that! |
#2
|
|||
|
|||
Something like
=VLOOKUP(A1,Sheet1!A1:E20,2,False) will return column 2, the name. -- HTH RP (remove nothere from the email address if mailing direct) "Fiona" wrote in message ... I have a file with two spreadsheets containing data. One contains a list of user defined entries, the other I want to summarise specific fields based upon the original entries in S/sheet 1. I am trying to use the lookup function to enter in S/sheet 2 the value driven by a field in s/sheet 1. Eg, S/sheet 1 has a client reference, names and other details. On S/sheet 2 I only want the client reference, name and one other field taken from fields in S/sheet 1. ie. Lookupif(A1="1")then return value in B2 Something messy like that! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow refence in the "table_array" position of Lookup functions | Excel Worksheet Functions | |||
Lookup Functions | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
Lookup Functions | Excel Worksheet Functions |