L
lee.dykeman
I have the following spreadsheets
Sheet 1 Sheet 2
Column A Column B Column C Column A Column B
Column C Column D
Row 1 750 750
Row 2 5000 $10,000
Row 3 5100 $15,000
In Sheet 1 column A Row 1 I have shop #, in column B row 2 and 3 I have
account #, in column C row 2 and 3 I have Dollar value.
I need a formula in Sheet 2 Column B that will say if Column A row 1
equals column A Row 1 on sheet 1, then find a certain account # in
column b (say the 5000) in sheet 1 and return the value in column C
which would be $10,000.
Is this possible?
Sheet 1 Sheet 2
Column A Column B Column C Column A Column B
Column C Column D
Row 1 750 750
Row 2 5000 $10,000
Row 3 5100 $15,000
In Sheet 1 column A Row 1 I have shop #, in column B row 2 and 3 I have
account #, in column C row 2 and 3 I have Dollar value.
I need a formula in Sheet 2 Column B that will say if Column A row 1
equals column A Row 1 on sheet 1, then find a certain account # in
column b (say the 5000) in sheet 1 and return the value in column C
which would be $10,000.
Is this possible?