Formula

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello form Steved

=SUMPRODUCT(--(FromVertex!A975=$A3),FromVertex!B975)

The above is the formula I wrote which is for this month.
Works only for the month i am doing, thefore net month the
data may be on B977 for example.

for this purpose we will call FromVertex, sheet2

A3 is City on sheet1, Row A975 is on sheet2 , which finds
City,Row B975 is the Value,to Sheet1.

Can I design the formula to look in Column A:A to find
City and then get the value of that row from Column B:B
Hopefully this explains What I hopefully will acheive.
Thankyou.
 
Hi
first you don't have to use SUMPRODUCT in your example. Try
=IF(FromVertex!A975=$A3,FromVertex!B975)
or event shorter as B975 is probably a number or blank
=(FromVertex!A975=$A3)*FromVertex!B975

For your next question use VLOOKUP. e.g.
=VLOOKUP("city",FromVertex!$A$1:$B$100,2,0)
 
Thankyou Frank I have over 10,000 lines of Data
and VLOOKUP is The formula for this worksheet.

ps I just was thinking that SUMPRODUCT would have been
more robust for this task but I was wrong.

Thankyou again.
 
Back
Top