looking for some solutions? You are welcome.

SOLVED: "Google Sheet" ,Compare two columns & return value


I want to do some function like sql joint table. But I really dont know if google sheet can do it.

I want to compare two columns and return the cost, how can I perform it?

ColA ColB                                  ColG ColH

Type Cost                                  Type Cost
A    100                                   B
B    200                                   E
C    300                                   D
D    400                                   A
E    500                                   C

I want colH would show colB data when comparing colG to colA, is there any function in google sheet that can do it? It's just like the joint table function sql table.


Posted in S.E.F
via StackOverflow & StackExchange Atomic Web Robots

No comments: