I want to extract some value according to station id.
Station ID Rainfall Evaporation
A 10 1
B 20 2
C 30 2
I want to extract all values corresponding to station B. How can i do it?
I want to extract some value according to station id.
Station ID Rainfall Evaporation
A 10 1
B 20 2
C 30 2
I want to extract all values corresponding to station B. How can i do it?
With the help of Vlookup you can extract the data
=VLOOKUP("A",A2:C4,1,TRUE)
Kamboj
_________________________________________________________________________________
Mark the thread as SOLVED if my answer satisfy you.
Hi,
Welcome to forum,
You can try this formula =VLOOKUP($E$2,$A$2:$C$4,MATCH(F$1,$A$1:$C$1,0),0)
Have a look in attached sheet.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks