Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
?formula
I have Two columns A & B on one sheet and two on another sheet C & D
If colum A = a number say 16 I would like it to find that number in Column C and put the number parallell to it in D in coulmn B. results would look like: A B C D 16 70 {placed here} [finds] 16 70 I do not know if any of thid makes sense but it would save me time if i could get thsi done. It would save looking up results in a table. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
?formula
Try this:
Assume: Sheet1 A1 = 16 Sheet2 C1 = 16, D1 = 70 I assume you have a table that is bigger than just C1:D1. Let's assume that table is C1:D10. Enter this formula in Sheet1 B1: =VLOOKUP(A1,Sheet2!C$1:D$10,2,0) Biff "EOB" wrote in message ... I have Two columns A & B on one sheet and two on another sheet C & D If colum A = a number say 16 I would like it to find that number in Column C and put the number parallell to it in D in coulmn B. results would look like: A B C D 16 70 {placed here} [finds] 16 70 I do not know if any of thid makes sense but it would save me time if i could get thsi done. It would save looking up results in a table. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|